package com.maomao.permission.mapper;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.maomao.permission.entity.User;

public interface UserMapper {
  

    @Select("SELECT * FROM P_USER WHERE ID = #{id}")
    @Results({
    	@Result(property = "id",column = "ID"),
    	@Result(property = "userCode",column = "USER_CODE"),
    	@Result(property = "userName",column = "USER_NAME"),
    	@Result(property = "password",column = "PASSWORD"),
    	@Result(property = "sysCode",column = "SYS_CODE"),
    	@Result(property = "compCode",column = "COMP_CODE"),
    	@Result(property = "qq",column = "QQ"),
    	@Result(property = "email",column = "EMAIL"),
    	@Result(property = "phone",column = "PHONE"),
    	@Result(property = "birthday",column = "BIRTHDAY"),
    	@Result(property = "salt",column = "SALT"),
    	@Result(property = "isValid",column = "IS_VALID"),
    	@Result(property = "createTime",column = "CREATE_TIME"),
    	@Result(property = "updateTime",column = "UPDATE_TIME"),
    	@Result(property = "createUser",column = "CREATE_USER"),
    	@Result(property = "updateUser",column = "UPDATE_USER")
    })
    User selectByPrimaryKey(Integer id);

}